Create table RidingApparel.RidingApparelInfo
(
RidingApparel_InfoID int identity(1,1) primary key,
AutoAccessoryProductType_InfoID int not null,
RidingApparelVariationData_InfoID int  not null,
ClothingType varchar(10),
Department_Arr10 nvarchar(500),
StyleKeywords_Arr10 nvarchar(max),
ModelName nvarchar(50),
ModelYear int ,
Season nvarchar(50),
RidingApparelColorSpecification_InfoID int,
Fabric_Arr10 nvarchar(max),
Material nvarchar(50),
InnerMaterial nvarchar(50),
OuterMaterial nvarchar(50),
SoleMaterial nvarchar(50),
ShoeClosureType nvarchar(50),
OccasionAndLifestyle_Arr10 nvarchar(max),
EventKeywords_Arr10 nvarchar(max), 
StyleName nvarchar(50),
MinimumHeightRecommended_LengthDimension_InfoID int,
MaximumHeightRecommended_LengthDimension_InfoID int,
CountryOfOrigin varchar(2),
IsAdultProduct bit ,
Size nvarchar(50),
SizeMap nvarchar(15),
SpecialSizeType_Arr10 nvarchar(500),
WaistSize_ClothingSizeDimension_InfoID int,
InseamLength_ClothingSizeDimension_InfoID int,
SleeveLength_ClothingSizeDimension_InfoID int,
NeckSize_ClothingSizeDimension_InfoID int,
ChestSize_ClothingSizeDimension_InfoID int,
CupSize varchar(3),
ShoeWidth varchar(5),
HeelHeight_LengthDimension_InfoID int,
HeelType nvarchar(50),
ShaftHeight_StringLengthOptionalDimension_InfoID int ,
BeltLength_LengthDimension_InfoID int,
BeltWidth_LengthDimension_InfoID int,
ItemPackageQuantity int default 1,
ManufacturerWarrantyDescription nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()

)


Create Table RidingApparel.RidingApparelVariationDataInfo
(
RidingApparelVariationData_InfoID int identity(1,1)primary key,
Parentage nvarchar(6) not null,
VariationTheme nvarchar(10) not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime datetime default getdate(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)
Create table RidingApparel.RidingApparelColorSpecificationInfo
(
RidingApparelColorSpecification_InfoID int identity(1,1)primary key,
Color nvarchar(50),
ColorMap nvarchar(50),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)